# coding=UTF-8
'''
Created on 2020-07-10 17:53
@author: jin
'''

import xlrd
import xlwt
from xlutils.copy import copy
import json


def write_excel_xls(path, sheet_name, value):
    index = len(value)  # 获取需要写入数据的行数
    workbook = xlwt.Workbook()  # 新建一个工作簿
    sheet = workbook.add_sheet(sheet_name)  # 在工作簿中新建一个表格
    for i in range(0, index):
        for j in range(0, len(value[i])):
            sheet.write(i, j, value[i][j])  # 像表格中写入数据（对应的行和列）
    workbook.save(path)  # 保存工作簿
    print("xls格式表格写入数据成功！")


def write_excel_xls_append(path, value):
    index = len(value)  # 获取需要写入数据的行数
    workbook = xlrd.open_workbook(path,formatting_info=True)  # 打开工作簿
    sheets = workbook.sheet_names()  # 获取工作簿中的所有表格
    worksheet = workbook.sheet_by_name(sheets[0])  # 获取工作簿中所有表格中的的第一个表格
    rows_old = worksheet.nrows  # 获取表格中已存在的数据的行数
    new_workbook = copy(workbook)  # 将xlrd对象拷贝转化为xlwt对象
    new_worksheet = new_workbook.get_sheet(0)  # 获取转化后工作簿中的第一个表格
    for i in range(0, index):
        for j in range(0, len(value[i])):
            new_worksheet.write(i + rows_old, j, value[i][j])  # 追加写入数据，注意是从i+rows_old行开始写入
    new_workbook.save(path)  # 保存工作簿
    print("xls格式表格【追加】写入数据成功！")


def read_excel_xls(path):
    workbook = xlrd.open_workbook(path)  # 打开工作簿
    sheets = workbook.sheet_names()  # 获取工作簿中的所有表格
    worksheet = workbook.sheet_by_name(sheets[0])  # 获取工作簿中所有表格中的的第一个表格
    data = []
    for i in range(0, worksheet.nrows):
        d = []
        for j in range(0, worksheet.ncols):
            d.append(worksheet.cell_value(i, j))
            # data[i][j]=worksheet.cell_value(i, j)
            # print(worksheet.cell_value(i, j), "\t", end="")  # 逐行逐列读取数据
        # print()
        data.append(d)
    return data


book_name_xls = 'xls格式测试工作簿.xls'

sheet_name_xls = 'xls格式测试表'

value_title = [['姓名', '性别', '年龄', '城市', '职业'], ]

value1 = [["张三", "男", "19", "杭州", "研发工程师"],
          ["李四", "男", "22", "北京", "医生"],
          ["王五", "女", "33", "珠海", "出租车司机"], ]

value2 = [["Tom", "男", "21", "西安", "测试工程师"],
          ["Jones", "女", "34", "上海", "产品经理"],
          ["Cat", "女", "56", "上海", "教师"], ]



def write_excel_merge_cells(path, sheet_name, value, merge_row):
    workbook = xlwt.Workbook()  # 新建一个工作簿
    sheet = workbook.add_sheet(sheet_name,cell_overwrite_ok=True)  # 在工作簿中新建一个表格
    for j in range(len(value[0])):
        if j in merge_row:
            if(j ==1):
                merge_list = merge_from_eq(j, sheet, value)
            else:
                merge_from_list(j, sheet, value,merge_list)
        else:
            for i in range(len(value)):
                sheet.write(i, j, value[i][j])
    workbook.save(path)  # 保存工作簿
    print("xls格式表格写入数据成功！")

def merge_from_list(j, sheet, value,merge_list):
    for i in range(len(value)):
        sheet.write(i, j, value[i][j])
    for merge in merge_list:
        if value[merge[0]][j] == value[merge[1]][j]:
            sheet.write_merge(merge[0], merge[1], j, j, value[merge[0]][j])

def merge_from_eq(j, sheet, value):
    merge_list =[]
    flag=0
    e = 0
    d = "test"
    merge_num=[0,0,0,0] #rrcc
    for i in range(len(value)):
        data = value[i][j]
        sheet.write(i, j, data)
        if d != data:
            d = data
            if (flag):
                flag = 0
                if (e > 0 & e < (i - 1)):
                    merge_num = [e, i - 1]
                    sheet.write_merge(e, i - 1, j, j, value[i - 1][j])
                    merge_list.append(merge_num)
                    print(merge_num)
        else:
            if (flag == 0):
                e = i - 1
            flag = 1
    if (flag):
        print(merge_num)
        if (e > 0 & e < (i - 1)):
            print(e, i, j, j)
            sheet.write_merge(e, i, j, j, value[i - 1][j])
            merge_list.append([e, i])
    return merge_list


if __name__ == '__main__':
    data = read_excel_xls(r"C:\Users\jin\Desktop\yr-bxba-001要素清单表And诉讼进程表(1).xls")
    # print(data)
    write_excel_merge_cells(r"C:\Users\jin\Desktop\yr-bxba-001要素清单表And诉讼进程表.xls",sheet_name_xls,data,[1,2,3,7,8,9,10,11,49,50,51,52,53,54,55,56,57,58,59,60,61,62])
    # path=r"D:\code\git\python\python_note\n3_dataSave\fund.xls"
    # value =[{"FCODE":"001683","SHORTNAME":"华夏新经济混合","ISHOT":"","ISBUY":"false","DTZT":"","DWJZ":"","LJJZ":"","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"","RZDF":"","FSRQ":"","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"","TradeBuyType":0,"gsz":"","gszzl":"","Order":0,"SGZT":"封闭期","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"163807","SHORTNAME":"中银优选混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.5392","LJJZ":"2.7448","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0053","RZDF":"0.35","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.5485","gszzl":"0.95","Order":1,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"486001","SHORTNAME":"工银全球股票(QDII)","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.5720","LJJZ":"2.2030","FUNDTYPE":"QDII","FTYPE":"QDII","RZDE":"0.0210","RZDF":"1.35","FSRQ":"2020-07-02","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.5750","gszzl":"0.19","Order":2,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"003956","SHORTNAME":"南方教育股票","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.9032","LJJZ":"1.9032","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0058","RZDF":"0.31","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.8949","gszzl":"-0.13","Order":3,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001573","SHORTNAME":"南方互联网+灵活配置混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.5140","LJJZ":"1.7090","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0090","RZDF":"0.60","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.5193","gszzl":"0.95","Order":4,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"007490","SHORTNAME":"南方信息创新混合A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.1197","LJJZ":"2.1197","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0173","RZDF":"0.82","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.1234","gszzl":"1.00","Order":5,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"003328","SHORTNAME":"万家鑫璟纯债C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1633","LJJZ":"1.2212","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"-0.0016","RZDF":"-0.14","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1648","gszzl":"-0.01","Order":6,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"163411","SHORTNAME":"兴全精选混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.7787","LJJZ":"3.2255","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0246","RZDF":"0.89","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.7906","gszzl":"1.32","Order":7,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000118","SHORTNAME":"广发聚鑫债券A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.4940","LJJZ":"2.0580","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"0.0050","RZDF":"0.34","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.4955","gszzl":"0.44","Order":8,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000751","SHORTNAME":"嘉实新兴产业股票","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"4.3260","LJJZ":"4.3260","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0200","RZDF":"0.46","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"4.3591","gszzl":"1.23","Order":9,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000362","SHORTNAME":"国泰聚信价值优势混合A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.3490","LJJZ":"3.3470","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0080","RZDF":"0.34","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.3558","gszzl":"0.63","Order":10,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"164206","SHORTNAME":"天弘添利债券(LOF)C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2986","LJJZ":"1.7919","FUNDTYPE":"ZQ,LOF","FTYPE":"债券型","RZDE":"0.0171","RZDF":"1.33","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.3012","gszzl":"1.54","Order":11,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001538","SHORTNAME":"上投摩根科技前沿灵活配置混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.1820","LJJZ":"2.1820","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0210","RZDF":"0.97","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.1817","gszzl":"0.96","Order":12,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"008282","SHORTNAME":"国泰CES半导体芯片行业ETF联接C","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.5296","LJJZ":"1.5296","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0133","RZDF":"0.88","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.5296","gszzl":"0.87","Order":13,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"161211","SHORTNAME":"国投沪深300金融地产联接","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.8486","LJJZ":"1.8486","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0620","RZDF":"3.47","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.8518","gszzl":"3.65","Order":14,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000962","SHORTNAME":"天弘中证500指数A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.0498","LJJZ":"1.0498","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0129","RZDF":"1.24","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.0495","gszzl":"1.22","Order":15,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001594","SHORTNAME":"天弘中证银行指数A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1796","LJJZ":"1.1796","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0289","RZDF":"2.51","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1795","gszzl":"2.50","Order":16,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"002974","SHORTNAME":"广发信息技术联接C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.3248","LJJZ":"1.3248","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0066","RZDF":"0.50","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.3247","gszzl":"0.49","Order":17,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"005064","SHORTNAME":"广发中证全指家用电器指数C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1268","LJJZ":"1.1268","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"-0.0008","RZDF":"-0.07","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1266","gszzl":"-0.09","Order":18,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"008585","SHORTNAME":"华夏中证人工智能主题ETF联接A","ISHOT":"","ISBUY":"false","DTZT":"0","DWJZ":"1.0026","LJJZ":"1.0026","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"","RZDF":"","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":0,"gsz":"1.0019","gszzl":"0.10","Order":19,"SGZT":"封闭期","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"008087","SHORTNAME":"华夏中证5G通信主题ETF联接C","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.2741","LJJZ":"1.2741","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0064","RZDF":"0.50","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2741","gszzl":"0.50","Order":20,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"008903","SHORTNAME":"广发科技先锋混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2723","LJJZ":"1.2723","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0091","RZDF":"0.72","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2722","gszzl":"0.71","Order":21,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"501010","SHORTNAME":"汇添富中证生物科技指数C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.1030","LJJZ":"2.1030","FUNDTYPE":"GP,ZS,LOF","FTYPE":"股票指数","RZDE":"0.0335","RZDF":"1.62","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.1007","gszzl":"1.51","Order":22,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"519674","SHORTNAME":"银河创新成长混合","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"6.0559","LJJZ":"6.0559","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"-0.0059","RZDF":"-0.10","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"6.0691","gszzl":"0.12","Order":23,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"007460","SHORTNAME":"华安成长创新混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.4876","LJJZ":"1.4876","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"-0.0016","RZDF":"-0.11","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.4976","gszzl":"0.57","Order":24,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"004851","SHORTNAME":"广发医疗保健股票A","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"2.9606","LJJZ":"2.9606","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0407","RZDF":"1.39","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.9647","gszzl":"1.53","Order":25,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001410","SHORTNAME":"信达澳银新能源产业股票","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"3.2030","LJJZ":"3.2650","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0120","RZDF":"0.38","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.2183","gszzl":"0.85","Order":26,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"162412","SHORTNAME":"华宝中证医疗指数分级","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1301","LJJZ":"0.6842","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0276","RZDF":"2.50","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1304","gszzl":"2.53","Order":27,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"004744","SHORTNAME":"易方达创业板ETF联接C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.4661","LJJZ":"2.4661","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0360","RZDF":"1.48","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.4663","gszzl":"1.49","Order":28,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"206009","SHORTNAME":"鹏华新兴产业混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"3.8240","LJJZ":"4.2010","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0230","RZDF":"0.61","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.8170","gszzl":"0.42","Order":29,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"020003","SHORTNAME":"国泰金龙行业混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"0.7350","LJJZ":"5.6240","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0040","RZDF":"0.55","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"0.7381","gszzl":"0.98","Order":30,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001102","SHORTNAME":"前海开源国家比较优势混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.7000","LJJZ":"2.7000","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0260","RZDF":"0.97","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.7061","gszzl":"1.20","Order":31,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"002079","SHORTNAME":"前海开源中国稀缺资产混合C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.2780","LJJZ":"2.2780","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0220","RZDF":"0.98","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.2845","gszzl":"1.26","Order":32,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001938","SHORTNAME":"中欧时代先锋股票A","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.7923","LJJZ":"2.4591","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0108","RZDF":"0.61","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.7993","gszzl":"1.00","Order":33,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"270042","SHORTNAME":"广发纳斯达克100指数A","ISHOT":"","ISBUY":"false","DTZT":"0","DWJZ":"3.2179","LJJZ":"3.4879","FUNDTYPE":"QDII","FTYPE":"QDII-指数","RZDE":"0.0132","RZDF":"0.41","FSRQ":"2020-07-02","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":0,"gsz":"3.2206","gszzl":"0.50","Order":34,"SGZT":"暂停申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000342","SHORTNAME":"嘉实新兴市场A1(QDII)","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2930","LJJZ":"1.5610","FUNDTYPE":"QDII","FTYPE":"QDII","RZDE":"0.0000","RZDF":"0.00","FSRQ":"2020-07-02","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2930","gszzl":"0.00","Order":35,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001061","SHORTNAME":"华夏收益债券(QDII)A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2760","LJJZ":"1.4780","FUNDTYPE":"QDII","FTYPE":"QDII","RZDE":"","RZDF":"","FSRQ":"2020-07-02","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"","gszzl":"","Order":36,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"180012","SHORTNAME":"银华富裕主题混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"4.8933","LJJZ":"5.8463","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0061","RZDF":"0.12","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"4.9143","gszzl":"0.55","Order":37,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"270044","SHORTNAME":"广发双债添利债券A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2021","LJJZ":"1.4485","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"0.0004","RZDF":"0.03","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2015","gszzl":"-0.01","Order":38,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"004042","SHORTNAME":"华夏鼎茂债券A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1309","LJJZ":"1.1872","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"-0.0005","RZDF":"-0.04","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1313","gszzl":"-0.01","Order":39,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"161716","SHORTNAME":"招商双债增强债券(LOF)C","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.3210","LJJZ":"1.4600","FUNDTYPE":"ZQ,LOF","FTYPE":"债券型","RZDE":"0.0020","RZDF":"0.15","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.3198","gszzl":"0.06","Order":40,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"206018","SHORTNAME":"鹏华产业债债券","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1490","LJJZ":"1.5470","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"0.0020","RZDF":"0.17","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1477","gszzl":"0.06","Order":41,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000601","SHORTNAME":"华宝创新优选混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.9460","LJJZ":"2.2860","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0210","RZDF":"1.09","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.9358","gszzl":"0.56","Order":42,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"003376","SHORTNAME":"广发中债7-10年国开债指数A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1173","LJJZ":"1.1283","FUNDTYPE":"ZQ,ZS","FTYPE":"债券指数","RZDE":"-0.0030","RZDF":"-0.27","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1202","gszzl":"-0.01","Order":43,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000406","SHORTNAME":"汇添富双利增强债券A","ISHOT":"","ISBUY":"true","DTZT":"0","DWJZ":"1.1670","LJJZ":"1.5000","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"0.0030","RZDF":"0.26","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1689","gszzl":"0.42","Order":44,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"260101","SHORTNAME":"景顺长城优选混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"3.1539","LJJZ":"5.8005","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0250","RZDF":"0.80","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.1655","gszzl":"1.17","Order":45,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000045","SHORTNAME":"工银产业债债券A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.5130","LJJZ":"1.6640","FUNDTYPE":"ZQ","FTYPE":"债券型","RZDE":"0.0030","RZDF":"0.20","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.5128","gszzl":"0.19","Order":46,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"004424","SHORTNAME":"汇添富文体娱乐混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.0832","LJJZ":"2.0832","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0222","RZDF":"1.08","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.0833","gszzl":"1.08","Order":47,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"005224","SHORTNAME":"广发中证基建工程指数C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"0.7255","LJJZ":"0.7255","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0122","RZDF":"1.71","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"0.7256","gszzl":"1.72","Order":48,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"501058","SHORTNAME":"汇添富中证新能源汽车C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2531","LJJZ":"1.2531","FUNDTYPE":"GP,ZS,LOF","FTYPE":"股票指数","RZDE":"0.0246","RZDF":"2.00","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2536","gszzl":"2.04","Order":49,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001714","SHORTNAME":"工银文体产业股票","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.4880","LJJZ":"2.6770","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0090","RZDF":"0.36","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.5068","gszzl":"1.12","Order":50,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"161903","SHORTNAME":"万家行业优选混合(LOF)","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.8396","LJJZ":"4.7778","FUNDTYPE":"HH,LOF","FTYPE":"混合型","RZDE":"0.0282","RZDF":"1.56","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.8508","gszzl":"2.18","Order":51,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001630","SHORTNAME":"天弘中证计算机ETF联接C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"0.9349","LJJZ":"0.9349","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0080","RZDF":"0.86","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"0.9349","gszzl":"0.86","Order":52,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"166002","SHORTNAME":"中欧新蓝筹混合A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.7738","LJJZ":"3.3510","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0178","RZDF":"1.01","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.7766","gszzl":"1.17","Order":53,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001878","SHORTNAME":"嘉实沪港深精选股票","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.7990","LJJZ":"1.8670","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0280","RZDF":"1.58","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.8038","gszzl":"1.85","Order":54,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"161028","SHORTNAME":"富国中证新能源汽车指数分级","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.0110","LJJZ":"0.9940","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0180","RZDF":"1.81","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.0119","gszzl":"1.90","Order":55,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001178","SHORTNAME":"前海开源再融资股票","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.8510","LJJZ":"2.0710","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"-0.0030","RZDF":"-0.16","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.8672","gszzl":"0.71","Order":56,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"519732","SHORTNAME":"交银定期支付双息平衡混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"4.7160","LJJZ":"4.7160","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0120","RZDF":"0.26","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"4.7264","gszzl":"0.48","Order":57,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"004075","SHORTNAME":"交银医药创新股票","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.8181","LJJZ":"2.8181","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"0.0297","RZDF":"1.07","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.8169","gszzl":"1.02","Order":58,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"519688","SHORTNAME":"交银精选混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.0125","LJJZ":"3.8243","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0047","RZDF":"0.47","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.0168","gszzl":"0.89","Order":59,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"519736","SHORTNAME":"交银新成长混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"3.3320","LJJZ":"3.7320","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0150","RZDF":"0.45","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.3466","gszzl":"0.89","Order":60,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"519772","SHORTNAME":"交银新生活力灵活配置混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.6250","LJJZ":"2.6250","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0060","RZDF":"0.23","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.6289","gszzl":"0.38","Order":61,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001595","SHORTNAME":"天弘中证银行指数C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.1655","LJJZ":"1.1655","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0285","RZDF":"2.51","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.1654","gszzl":"2.50","Order":62,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001668","SHORTNAME":"汇添富全球互联混合","ISHOT":"","ISBUY":"false","DTZT":"0","DWJZ":"2.3520","LJJZ":"2.3520","FUNDTYPE":"QDII","FTYPE":"QDII","RZDE":"0.0330","RZDF":"1.42","FSRQ":"2020-07-02","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":0,"gsz":"2.3573","gszzl":"0.22","Order":63,"SGZT":"暂停申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"162213","SHORTNAME":"泰达宏利沪深300指数增强A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.8744","LJJZ":"2.3144","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0330","RZDF":"1.79","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.8752","gszzl":"1.83","Order":64,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"040046","SHORTNAME":"华安纳斯达克100指数","ISHOT":"","ISBUY":"false","DTZT":"0","DWJZ":"3.2790","LJJZ":"3.2790","FUNDTYPE":"QDII","FTYPE":"QDII-指数","RZDE":"0.0140","RZDF":"0.43","FSRQ":"2020-07-02","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":0,"gsz":"3.2953","gszzl":"0.50","Order":65,"SGZT":"暂停申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000083","SHORTNAME":"汇添富消费行业混合","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"6.4060","LJJZ":"6.4060","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0410","RZDF":"0.64","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"6.3737","gszzl":"0.14","Order":66,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"005918","SHORTNAME":"天弘沪深300ETF联接C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2023","LJJZ":"1.2023","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0222","RZDF":"1.88","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2017","gszzl":"1.83","Order":67,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"161031","SHORTNAME":"富国中证工业4.0指数分级","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.2910","LJJZ":"0.7160","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0090","RZDF":"0.70","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2913","gszzl":"0.72","Order":68,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"110011","SHORTNAME":"易方达中小盘混合","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"6.3369","LJJZ":"7.2269","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0209","RZDF":"0.33","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"6.3482","gszzl":"0.51","Order":69,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"540012","SHORTNAME":"汇丰晋信恒生龙头指数A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.6879","LJJZ":"2.2679","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0164","RZDF":"0.98","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.6866","gszzl":"0.91","Order":70,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001548","SHORTNAME":"天弘上证50指数A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.3308","LJJZ":"1.3308","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"0.0304","RZDF":"2.34","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.3304","gszzl":"2.31","Order":71,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"100039","SHORTNAME":"富国通胀通缩主题轮动混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"3.0210","LJJZ":"3.0710","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0050","RZDF":"0.17","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.0241","gszzl":"0.27","Order":72,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"519069","SHORTNAME":"汇添富价值精选混合A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"3.1580","LJJZ":"4.7450","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0450","RZDF":"1.45","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.1640","gszzl":"1.64","Order":73,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"003766","SHORTNAME":"广发创业板ETF联接C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"1.3372","LJJZ":"1.3372","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"0.0194","RZDF":"1.47","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.3375","gszzl":"1.49","Order":74,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"005911","SHORTNAME":"广发双擎升级混合A","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"2.9763","LJJZ":"3.1092","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0178","RZDF":"0.60","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.0004","gszzl":"1.42","Order":75,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"000248","SHORTNAME":"汇添富中证主要消费ETF联接","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.5665","LJJZ":"2.5665","FUNDTYPE":"GP,ZS,ETF","FTYPE":"联接基金","RZDE":"-0.0021","RZDF":"-0.08","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.5666","gszzl":"-0.08","Order":76,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"162703","SHORTNAME":"广发小盘成长混合(LOF)A","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"3.0253","LJJZ":"5.3633","FUNDTYPE":"HH,LOF","FTYPE":"混合型","RZDE":"0.0244","RZDF":"0.81","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.0370","gszzl":"1.20","Order":77,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"001632","SHORTNAME":"天弘中证食品饮料指数C","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.4177","LJJZ":"2.4953","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"-0.0183","RZDF":"-0.75","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.4177","gszzl":"-0.75","Order":78,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"160222","SHORTNAME":"国泰国证食品饮料行业指数分级","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.4125","LJJZ":"2.6594","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"-0.0096","RZDF":"-0.68","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.4121","gszzl":"-0.70","Order":79,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"260108","SHORTNAME":"景顺长城新兴成长混合","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.2450","LJJZ":"3.8820","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"0.0200","RZDF":"0.90","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.2350","gszzl":"0.45","Order":80,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"110022","SHORTNAME":"易方达消费行业股票","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"3.5800","LJJZ":"3.5800","FUNDTYPE":"GP","FTYPE":"股票型","RZDE":"-0.0260","RZDF":"-0.72","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"3.5844","gszzl":"-0.60","Order":81,"SGZT":"开放申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"162605","SHORTNAME":"景顺长城鼎益混合(LOF)","ISHOT":"","ISBUY":"true","DTZT":"1","DWJZ":"2.2600","LJJZ":"5.0510","FUNDTYPE":"HH,LOF","FTYPE":"混合型","RZDE":"0.0120","RZDF":"0.53","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"2.2406","gszzl":"-0.33","Order":82,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"161725","SHORTNAME":"招商中证白酒指数分级","ISHOT":"1.0","ISBUY":"true","DTZT":"1","DWJZ":"1.2801","LJJZ":"2.4062","FUNDTYPE":"GP,ZS","FTYPE":"股票指数","RZDE":"-0.0127","RZDF":"-0.98","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":22,"gsz":"1.2801","gszzl":"-0.98","Order":83,"SGZT":"限大额","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"},{"FCODE":"009623","SHORTNAME":"长城创新驱动混合","ISHOT":"","ISBUY":"false","DTZT":"0","DWJZ":"1.0037","LJJZ":"1.0037","FUNDTYPE":"HH","FTYPE":"混合型","RZDE":"","RZDF":"","FSRQ":"2020-07-03","IPESTART1":"","IPEEND1":"","SHIPESTART1":"","SHIPEEND1":"","ISSALES":"1","TradeBuyType":0,"gsz":"","gszzl":"","Order":84,"SGZT":"暂停申购","ISSBDATE":"null","ISSEDATE":"null","ISNEW":"null","KFR":"null"}]
    # # data = json.dumps(jso)
    # index = len(value)  # 获取需要写入数据的行数
    # workbook = xlrd.open_workbook(path)  # 打开工作簿
    # sheets = workbook.sheet_names()  # 获取工作簿中的所有表格
    # worksheet = workbook.sheet_by_name(sheets[0])  # 获取工作簿中所有表格中的的第一个表格
    # rows_old = worksheet.nrows  # 获取表格中已存在的数据的行数
    # new_workbook = copy(workbook)  # 将xlrd对象拷贝转化为xlwt对象
    # new_worksheet = new_workbook.get_sheet(0)  # 获取转化后工作簿中的第一个表格
    # # 代码	名称	价格	类型	时间	类型
    # for i in range(0, index):
    #     # for j in range(0, len(value[i])):
    #     # value =json.dumps(data[i])
    #     new_worksheet.write(i+rows_old, 0, value[i]["FCODE"])  # 追加写入数据，注意是从i+rows_old行开始写入
    #     new_worksheet.write(i+rows_old, 1, value[i]["SHORTNAME"])  # 追加写入数据，注意是从i+rows_old行开始写入
    #     new_worksheet.write(i+rows_old, 2, value[i]["DWJZ"])  # 追加写入数据，注意是从i+rows_old行开始写入
    #     new_worksheet.write(i+rows_old, 3, value[i]["FTYPE"])  # 追加写入数据，注意是从i+rows_old行开始写入
    #     new_worksheet.write(i+rows_old, 4, value[i]["FSRQ"])  # 追加写入数据，注意是从i+rows_old行开始写入
    #     new_worksheet.write(i+rows_old, 5, value[i]["FUNDTYPE"])  # 追加写入数据，注意是从i+rows_old行开始写入
    # new_workbook.save(path)  # 保存工作簿
    # print("xls格式表格【追加】写入数据成功！")
    #
    # read_excel_xls(path)
    # write_excel_xls(book_name_xls, sheet_name_xls, value_title)
    # write_excel_xls_append(book_name_xls, value1)
    # write_excel_xls_append(book_name_xls, value2)
    # read_excel_xls(book_name_xls)
# if __name__ == '__main__':
# path=r"D:\code\git\python\python_note\n3_dataSave\fund.xls"
# value =[{"FCODE":"001683","SHORTNAME":"华夏新经济混合","FSRQ":"","SYRQ":"2018-11-28","SYL_Z":"0.0","SYL_Y":"0.0","SYL_3Y":"-0.9346","SYL_6Y":"-11.3383","SYL_JN":"-13.1938","SYL_1N":"-13.8989","SYL_2N":"-6.6536","SYL_3N":"-4.1206","SYL_5N":"","SYL_AddFavor":"null","FUNDTYPE":"HH","FEATURE":"080,211","FavorDate":"2020-07-04"},{"FCODE":"163807","SHORTNAME":"中银优选混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.0392","SYL_Y":"11.3345","SYL_3Y":"23.2239","SYL_6Y":"23.386","SYL_JN":"26.6658","SYL_1N":"61.4593","SYL_2N":"72.9944","SYL_3N":"81.51","SYL_5N":"68.9421","SYL_AddFavor":"0.00","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-03"},{"FCODE":"486001","SHORTNAME":"工银全球股票(QDII)","FSRQ":"2020-07-02","SYRQ":"2020-07-02","SYL_Z":"2.4772","SYL_Y":"6.0014","SYL_3Y":"27.2875","SYL_6Y":"10.7003","SYL_JN":"12.0417","SYL_1N":"23.1123","SYL_2N":"34.2104","SYL_3N":"58.1674","SYL_5N":"98.5195","SYL_AddFavor":"null","FUNDTYPE":"QDII","FEATURE":"311","FavorDate":"2020-07-03"},{"FCODE":"003956","SHORTNAME":"南方教育股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.1414","SYL_Y":"10.8574","SYL_3Y":"30.1778","SYL_6Y":"30.4098","SYL_JN":"35.8361","SYL_1N":"95.9234","SYL_2N":"120.8145","SYL_3N":"91.4303","SYL_5N":"","SYL_AddFavor":"0.00","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-03"},{"FCODE":"001573","SHORTNAME":"南方互联网+灵活配置混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.7834","SYL_Y":"12.1481","SYL_3Y":"19.3065","SYL_6Y":"36.4049","SYL_JN":"42.4912","SYL_1N":"80.2087","SYL_2N":"82.0627","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.00","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-03"},{"FCODE":"007490","SHORTNAME":"南方信息创新混合A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.0037","SYL_Y":"17.4089","SYL_3Y":"34.4902","SYL_6Y":"36.9315","SYL_JN":"41.3039","SYL_1N":"111.2096","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.00","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-03"},{"FCODE":"003328","SHORTNAME":"万家鑫璟纯债C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.0086","SYL_Y":"0.0517","SYL_3Y":"0.4317","SYL_6Y":"4.0892","SYL_JN":"4.0892","SYL_1N":"7.2166","SYL_2N":"15.3495","SYL_3N":"20.4347","SYL_5N":"","SYL_AddFavor":"0.00","FUNDTYPE":"ZQ","FEATURE":"041","FavorDate":"2020-07-03"},{"FCODE":"163411","SHORTNAME":"兴全精选混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.3397","SYL_Y":"14.0682","SYL_3Y":"31.0398","SYL_6Y":"24.9809","SYL_JN":"28.1393","SYL_1N":"64.7515","SYL_2N":"76.5936","SYL_3N":"111.0351","SYL_5N":"137.882","SYL_AddFavor":"0.00","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-03"},{"FCODE":"000118","SHORTNAME":"广发聚鑫债券A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.5636","SYL_Y":"2.9635","SYL_3Y":"4.7476","SYL_6Y":"8.8425","SYL_JN":"9.6079","SYL_1N":"22.744","SYL_2N":"34.2796","SYL_3N":"35.961","SYL_5N":"40.8655","SYL_AddFavor":"0.00","FUNDTYPE":"ZQ","FEATURE":"043","FavorDate":"2020-07-03"},{"FCODE":"000751","SHORTNAME":"嘉实新兴产业股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.3905","SYL_Y":"12.4805","SYL_3Y":"31.4095","SYL_6Y":"40.8662","SYL_JN":"41.6503","SYL_1N":"73.1092","SYL_2N":"104.9266","SYL_3N":"137.6923","SYL_5N":"174.4924","SYL_AddFavor":"0.00","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-03"},{"FCODE":"000362","SHORTNAME":"国泰聚信价值优势混合A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.3891","SYL_Y":"14.9217","SYL_3Y":"26.087","SYL_6Y":"47.2728","SYL_JN":"50.1918","SYL_1N":"86.4286","SYL_2N":"106.5963","SYL_3N":"99.9149","SYL_5N":"152.9202","SYL_AddFavor":"0.00","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-03"},{"FCODE":"164206","SHORTNAME":"天弘添利债券(LOF)C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.3506","SYL_Y":"2.027","SYL_3Y":"0.5887","SYL_6Y":"7.0569","SYL_JN":"7.7677","SYL_1N":"15.843","SYL_2N":"20.2408","SYL_3N":"24.0306","SYL_5N":"42.9083","SYL_AddFavor":"0.00","FUNDTYPE":"ZQ,LOF","FEATURE":"020,043","FavorDate":"2020-07-03"},{"FCODE":"001538","SHORTNAME":"上投摩根科技前沿灵活配置混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.1527","SYL_Y":"17.8186","SYL_3Y":"37.5788","SYL_6Y":"46.7384","SYL_JN":"48.5364","SYL_1N":"80.033","SYL_2N":"114.9754","SYL_3N":"120.1816","SYL_5N":"","SYL_AddFavor":"0.97","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-02"},{"FCODE":"008282","SHORTNAME":"国泰CES半导体芯片行业ETF联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.3953","SYL_Y":"11.4869","SYL_3Y":"26.0175","SYL_6Y":"42.6866","SYL_JN":"47.1618","SYL_1N":"","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.88","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054,080","FavorDate":"2020-07-02"},{"FCODE":"161211","SHORTNAME":"国投沪深300金融地产联接","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"9.6246","SYL_Y":"11.1338","SYL_3Y":"17.2746","SYL_6Y":"1.5101","SYL_JN":"2.7571","SYL_1N":"7.5455","SYL_2N":"40.1941","SYL_3N":"31.4981","SYL_5N":"34.7573","SYL_AddFavor":"3.47","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054","FavorDate":"2020-07-02"},{"FCODE":"000962","SHORTNAME":"天弘中证500指数A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.4889","SYL_Y":"9.0701","SYL_3Y":"19.0114","SYL_6Y":"13.3326","SYL_JN":"15.655","SYL_1N":"22.084","SYL_2N":"21.4063","SYL_3N":"4.4473","SYL_5N":"-15.7869","SYL_AddFavor":"1.24","FUNDTYPE":"GP,ZS","FEATURE":"050,051,053,080","FavorDate":"2020-07-02"},{"FCODE":"001594","SHORTNAME":"天弘中证银行指数A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.5486","SYL_Y":"4.5745","SYL_3Y":"8.8594","SYL_6Y":"-7.8293","SYL_JN":"-6.2321","SYL_1N":"0.6571","SYL_2N":"23.2216","SYL_3N":"15.5677","SYL_5N":"","SYL_AddFavor":"2.51","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,080","FavorDate":"2020-07-02"},{"FCODE":"002974","SHORTNAME":"广发信息技术联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.2983","SYL_Y":"11.1409","SYL_3Y":"20.2615","SYL_6Y":"19.1689","SYL_JN":"23.709","SYL_1N":"45.6945","SYL_2N":"46.9226","SYL_3N":"29.8061","SYL_5N":"","SYL_AddFavor":"0.50","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054,080","FavorDate":"2020-07-02"},{"FCODE":"005064","SHORTNAME":"广发中证全指家用电器指数C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.269","SYL_Y":"5.161","SYL_3Y":"18.1628","SYL_6Y":"4.0635","SYL_JN":"5.2789","SYL_1N":"11.7968","SYL_2N":"17.6692","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"-0.07","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,080","FavorDate":"2020-07-02"},{"FCODE":"008585","SHORTNAME":"华夏中证人工智能主题ETF联接A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.2299","SYL_Y":"","SYL_3Y":"","SYL_6Y":"","SYL_JN":"","SYL_1N":"","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.00","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054,080","FavorDate":"2020-07-02"},{"FCODE":"008087","SHORTNAME":"华夏中证5G通信主题ETF联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.2329","SYL_Y":"12.3545","SYL_3Y":"22.5568","SYL_6Y":"23.9276","SYL_JN":"27.6398","SYL_1N":"","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"1.00","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054,080","FavorDate":"2020-07-01"},{"FCODE":"008903","SHORTNAME":"广发科技先锋混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.2376","SYL_Y":"13.4868","SYL_3Y":"20.9871","SYL_6Y":"","SYL_JN":"","SYL_1N":"","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.27","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"501010","SHORTNAME":"汇添富中证生物科技指数C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.6413","SYL_Y":"15.1256","SYL_3Y":"35.0674","SYL_6Y":"58.6212","SYL_JN":"57.8473","SYL_1N":"78.6442","SYL_2N":"72.0105","SYL_3N":"99.5067","SYL_5N":"","SYL_AddFavor":"0.43","FUNDTYPE":"GP,ZS,LOF","FEATURE":"020,050,051,054,080","FavorDate":"2020-07-01"},{"FCODE":"519674","SHORTNAME":"银河创新成长混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.7573","SYL_Y":"10.8246","SYL_3Y":"25.078","SYL_6Y":"42.875","SYL_JN":"50.3152","SYL_1N":"130.4025","SYL_2N":"142.8675","SYL_3N":"150.627","SYL_5N":"164.8546","SYL_AddFavor":"1.17","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"007460","SHORTNAME":"华安成长创新混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.5912","SYL_Y":"11.3723","SYL_3Y":"18.989","SYL_6Y":"8.481","SYL_JN":"13.4879","SYL_1N":"48.7749","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"1.13","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"004851","SHORTNAME":"广发医疗保健股票A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.2517","SYL_Y":"15.2612","SYL_3Y":"48.535","SYL_6Y":"74.7285","SYL_JN":"73.632","SYL_1N":"114.8788","SYL_2N":"122.2005","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"-0.38","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"001410","SHORTNAME":"信达澳银新能源产业股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.9904","SYL_Y":"9.1312","SYL_3Y":"21.5098","SYL_6Y":"33.5696","SYL_JN":"38.7782","SYL_1N":"107.8521","SYL_2N":"140.2851","SYL_3N":"163.8281","SYL_5N":"","SYL_AddFavor":"1.20","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"162412","SHORTNAME":"华宝中证医疗指数分级","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.5406","SYL_Y":"15.8701","SYL_3Y":"34.8281","SYL_6Y":"54.142","SYL_JN":"53.5683","SYL_1N":"80.9321","SYL_2N":"80.6174","SYL_3N":"97.0604","SYL_5N":"6.4168","SYL_AddFavor":"1.14","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,060,070","FavorDate":"2020-07-01"},{"FCODE":"004744","SHORTNAME":"易方达创业板ETF联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.1409","SYL_Y":"14.3619","SYL_3Y":"27.6912","SYL_6Y":"31.1685","SYL_JN":"33.7727","SYL_1N":"54.1119","SYL_2N":"48.4082","SYL_3N":"29.6788","SYL_5N":"","SYL_AddFavor":"1.66","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,053","FavorDate":"2020-07-01"},{"FCODE":"206009","SHORTNAME":"鹏华新兴产业混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.8918","SYL_Y":"8.2366","SYL_3Y":"33.6596","SYL_6Y":"46.5134","SYL_JN":"51.3856","SYL_1N":"75.4933","SYL_2N":"84.7961","SYL_3N":"90.261","SYL_5N":"104.0965","SYL_AddFavor":"0.84","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"020003","SHORTNAME":"国泰金龙行业混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.823","SYL_Y":"13.7771","SYL_3Y":"21.0873","SYL_6Y":"26.506","SYL_JN":"27.8261","SYL_1N":"50.924","SYL_2N":"40.5354","SYL_3N":"17.8909","SYL_5N":"95.8354","SYL_AddFavor":"-0.54","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"001102","SHORTNAME":"前海开源国家比较优势混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.5673","SYL_Y":"15.8798","SYL_3Y":"37.4046","SYL_6Y":"48.7603","SYL_JN":"48.5149","SYL_1N":"73.0769","SYL_2N":"90.8127","SYL_3N":"114.9682","SYL_5N":"174.3902","SYL_AddFavor":"0.15","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"002079","SHORTNAME":"前海开源中国稀缺资产混合C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.5925","SYL_Y":"16.2245","SYL_3Y":"37.977","SYL_6Y":"52.171","SYL_JN":"51.968","SYL_1N":"74.026","SYL_2N":"163.9629","SYL_3N":"158.5698","SYL_5N":"","SYL_AddFavor":"0.04","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"001938","SHORTNAME":"中欧时代先锋股票A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.1599","SYL_Y":"11.557","SYL_3Y":"23.3943","SYL_6Y":"16.3961","SYL_JN":"19.1143","SYL_1N":"51.144","SYL_2N":"78.685","SYL_3N":"97.6724","SYL_5N":"","SYL_AddFavor":"1.05","FUNDTYPE":"GP","FEATURE":"080","FavorDate":"2020-07-01"},{"FCODE":"270042","SHORTNAME":"广发纳斯达克100指数A","FSRQ":"2020-07-02","SYRQ":"2020-07-02","SYL_Z":"3.2901","SYL_Y":"6.275","SYL_3Y":"34.1463","SYL_6Y":"15.4859","SYL_JN":"17.104","SYL_1N":"32.9821","SYL_2N":"49.6698","SYL_3N":"85.1496","SYL_5N":"158.8253","SYL_AddFavor":"0.41","FUNDTYPE":"QDII","FEATURE":"055,317,318","FavorDate":"2020-07-01"},{"FCODE":"000342","SHORTNAME":"嘉实新兴市场A1(QDII)","FSRQ":"2020-07-02","SYRQ":"2020-07-02","SYL_Z":"0.1549","SYL_Y":"1.811","SYL_3Y":"12.2396","SYL_6Y":"-5.2747","SYL_JN":"-5.2747","SYL_1N":"-2.4151","SYL_2N":"13.1234","SYL_3N":"9.6692","SYL_5N":"35.7222","SYL_AddFavor":"0.00","FUNDTYPE":"QDII","FEATURE":"330","FavorDate":"2020-07-01"},{"FCODE":"001061","SHORTNAME":"华夏收益债券(QDII)A","FSRQ":"2020-07-02","SYRQ":"2020-07-02","SYL_Z":"0.3145","SYL_Y":"1.2699","SYL_3Y":"8.9667","SYL_6Y":"-5.969","SYL_JN":"-5.8997","SYL_1N":"-1.7959","SYL_2N":"10.8943","SYL_3N":"7.1827","SYL_5N":"32.1576","SYL_AddFavor":"0.00","FUNDTYPE":"QDII","FEATURE":"330","FavorDate":"2020-07-01"},{"FCODE":"180012","SHORTNAME":"银华富裕主题混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.1459","SYL_Y":"12.3528","SYL_3Y":"33.2925","SYL_6Y":"38.6008","SYL_JN":"36.5013","SYL_1N":"49.4411","SYL_2N":"82.2051","SYL_3N":"114.3552","SYL_5N":"204.9735","SYL_AddFavor":"-0.26","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"270044","SHORTNAME":"广发双债添利债券A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.1917","SYL_Y":"-0.2941","SYL_3Y":"-0.1385","SYL_6Y":"2.1724","SYL_JN":"2.2742","SYL_1N":"4.688","SYL_2N":"11.9517","SYL_3N":"16.7765","SYL_5N":"30.9945","SYL_AddFavor":"0.07","FUNDTYPE":"ZQ","FEATURE":"041","FavorDate":"2020-07-01"},{"FCODE":"004042","SHORTNAME":"华夏鼎茂债券A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.124","SYL_Y":"-0.1501","SYL_3Y":"-0.4314","SYL_6Y":"2.1036","SYL_JN":"2.1959","SYL_1N":"4.3679","SYL_2N":"12.0277","SYL_3N":"18.2851","SYL_5N":"","SYL_AddFavor":"-0.01","FUNDTYPE":"ZQ","FEATURE":"041","FavorDate":"2020-07-01"},{"FCODE":"161716","SHORTNAME":"招商双债增强债券(LOF)C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.5327","SYL_Y":"0.2276","SYL_3Y":"0.0757","SYL_6Y":"2.4825","SYL_JN":"2.6418","SYL_1N":"5.5955","SYL_2N":"15.17","SYL_3N":"20.5291","SYL_5N":"31.4428","SYL_AddFavor":"0.38","FUNDTYPE":"ZQ,LOF","FEATURE":"020,041","FavorDate":"2020-07-01"},{"FCODE":"206018","SHORTNAME":"鹏华产业债债券","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.613","SYL_Y":"0.3493","SYL_3Y":"0.6911","SYL_6Y":"2.9691","SYL_JN":"3.2384","SYL_1N":"7.2947","SYL_2N":"17.5375","SYL_3N":"24.9235","SYL_5N":"33.9712","SYL_AddFavor":"0.44","FUNDTYPE":"ZQ","FEATURE":"041","FavorDate":"2020-07-01"},{"FCODE":"000601","SHORTNAME":"华宝创新优选混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.3432","SYL_Y":"19.0942","SYL_3Y":"37.4294","SYL_6Y":"41.7334","SYL_JN":"47.536","SYL_1N":"98.5715","SYL_2N":"115.9822","SYL_3N":"110.606","SYL_5N":"86.7563","SYL_AddFavor":"0.41","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"003376","SHORTNAME":"广发中债7-10年国开债指数A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.0269","SYL_Y":"-0.1643","SYL_3Y":"-1.0486","SYL_6Y":"3.2902","SYL_JN":"3.1958","SYL_1N":"5.6402","SYL_2N":"13.7786","SYL_3N":"18.5358","SYL_5N":"","SYL_AddFavor":"-0.21","FUNDTYPE":"ZQ,ZS","FEATURE":"041,050,051,053","FavorDate":"2020-07-01"},{"FCODE":"000406","SHORTNAME":"汇添富双利增强债券A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.1265","SYL_Y":"1.9214","SYL_3Y":"2.0105","SYL_6Y":"4.0107","SYL_JN":"4.3828","SYL_1N":"8.7605","SYL_2N":"14.2037","SYL_3N":"21.5523","SYL_5N":"32.5838","SYL_AddFavor":"0.34","FUNDTYPE":"ZQ","FEATURE":"043","FavorDate":"2020-07-01"},{"FCODE":"260101","SHORTNAME":"景顺长城优选混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.7289","SYL_Y":"7.892","SYL_3Y":"17.5075","SYL_6Y":"21.7722","SYL_JN":"23.6193","SYL_1N":"49.0322","SYL_2N":"59.2583","SYL_3N":"61.4959","SYL_5N":"105.7369","SYL_AddFavor":"1.09","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"000045","SHORTNAME":"工银产业债债券A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.0688","SYL_Y":"1.6118","SYL_3Y":"2.8552","SYL_6Y":"3.1356","SYL_JN":"3.4883","SYL_1N":"7.153","SYL_2N":"16.7438","SYL_3N":"20.366","SYL_5N":"29.8856","SYL_AddFavor":"0.53","FUNDTYPE":"ZQ","FEATURE":"043","FavorDate":"2020-07-01"},{"FCODE":"004424","SHORTNAME":"汇添富文体娱乐混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.0507","SYL_Y":"10.0127","SYL_3Y":"35.2991","SYL_6Y":"37.1068","SYL_JN":"39.019","SYL_1N":"63.7478","SYL_2N":"108.1743","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"1.70","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"005224","SHORTNAME":"广发中证基建工程指数C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"5.0536","SYL_Y":"3.0833","SYL_3Y":"1.7674","SYL_6Y":"-6.9395","SYL_JN":"-4.9148","SYL_1N":"-8.6847","SYL_2N":"-6.4354","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"3.79","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,080","FavorDate":"2020-07-01"},{"FCODE":"501058","SHORTNAME":"汇添富中证新能源汽车C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.4082","SYL_Y":"13.7424","SYL_3Y":"28.4835","SYL_6Y":"19.582","SYL_JN":"22.1583","SYL_1N":"46.4415","SYL_2N":"27.9849","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"2.05","FUNDTYPE":"GP,ZS,LOF","FEATURE":"020,050,051,054,080","FavorDate":"2020-07-01"},{"FCODE":"001714","SHORTNAME":"工银文体产业股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.9801","SYL_Y":"13.5554","SYL_3Y":"33.7634","SYL_6Y":"30.9473","SYL_JN":"34.632","SYL_1N":"66.4214","SYL_2N":"93.8025","SYL_3N":"119.0089","SYL_5N":"","SYL_AddFavor":"0.48","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"161903","SHORTNAME":"万家行业优选混合(LOF)","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.3137","SYL_Y":"15.6109","SYL_3Y":"33.1018","SYL_6Y":"61.0578","SYL_JN":"63.9121","SYL_1N":"113.5155","SYL_2N":"186.4328","SYL_3N":"161.7516","SYL_5N":"250.2866","SYL_AddFavor":"0.19","FUNDTYPE":"HH,LOF","FEATURE":"020,211","FavorDate":"2020-07-01"},{"FCODE":"001630","SHORTNAME":"天弘中证计算机ETF联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.3039","SYL_Y":"10.456","SYL_3Y":"15.7054","SYL_6Y":"20.2134","SYL_JN":"24.0908","SYL_1N":"36.3424","SYL_2N":"45.782","SYL_3N":"40.8831","SYL_5N":"","SYL_AddFavor":"1.54","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054","FavorDate":"2020-07-01"},{"FCODE":"166002","SHORTNAME":"中欧新蓝筹混合A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.3657","SYL_Y":"9.2107","SYL_3Y":"18.5062","SYL_6Y":"15.9877","SYL_JN":"17.4858","SYL_1N":"34.859","SYL_2N":"65.0134","SYL_3N":"70.9549","SYL_5N":"113.3741","SYL_AddFavor":"1.66","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"001878","SHORTNAME":"嘉实沪港深精选股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.4497","SYL_Y":"14.659","SYL_3Y":"27.2278","SYL_6Y":"9.1626","SYL_JN":"10.9809","SYL_1N":"26.8688","SYL_2N":"24.2403","SYL_3N":"31.1526","SYL_5N":"","SYL_AddFavor":"4.17","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"161028","SHORTNAME":"富国中证新能源汽车指数分级","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.5356","SYL_Y":"13.0873","SYL_3Y":"27.813","SYL_6Y":"20.2413","SYL_JN":"22.7339","SYL_1N":"61.4265","SYL_2N":"33.9225","SYL_3N":"15.8965","SYL_5N":"9.9539","SYL_AddFavor":"1.61","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,060,070","FavorDate":"2020-07-01"},{"FCODE":"001178","SHORTNAME":"前海开源再融资股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.3217","SYL_Y":"9.268","SYL_3Y":"18.0485","SYL_6Y":"14.613","SYL_JN":"17.3747","SYL_1N":"34.6182","SYL_2N":"71.2303","SYL_3N":"78.2862","SYL_5N":"127.2877","SYL_AddFavor":"1.04","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"519732","SHORTNAME":"交银定期支付双息平衡混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"1.5941","SYL_Y":"7.4749","SYL_3Y":"18.2251","SYL_6Y":"23.4555","SYL_JN":"25.1925","SYL_1N":"50.0955","SYL_2N":"60.1902","SYL_3N":"114.6563","SYL_5N":"179.2185","SYL_AddFavor":"0.23","FUNDTYPE":"HH","FEATURE":"044,212","FavorDate":"2020-07-01"},{"FCODE":"004075","SHORTNAME":"交银医药创新股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.4169","SYL_Y":"15.4959","SYL_3Y":"43.0217","SYL_6Y":"61.681","SYL_JN":"59.9921","SYL_1N":"97.9559","SYL_2N":"120.7159","SYL_3N":"170.3213","SYL_5N":"","SYL_AddFavor":"-0.42","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"519688","SHORTNAME":"交银精选混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.0489","SYL_Y":"10.4264","SYL_3Y":"22.4009","SYL_6Y":"21.1704","SYL_JN":"22.3713","SYL_1N":"43.4982","SYL_2N":"70.747","SYL_3N":"91.4648","SYL_5N":"132.2345","SYL_AddFavor":"0.97","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"519736","SHORTNAME":"交银新成长混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"4.1576","SYL_Y":"10.7345","SYL_3Y":"22.8614","SYL_6Y":"21.7836","SYL_JN":"22.952","SYL_1N":"44.43","SYL_2N":"71.9298","SYL_3N":"90.206","SYL_5N":"171.3572","SYL_AddFavor":"0.94","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"519772","SHORTNAME":"交银新生活力灵活配置混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.021","SYL_Y":"9.4662","SYL_3Y":"22.4918","SYL_6Y":"28.2991","SYL_JN":"30.7271","SYL_1N":"63.6534","SYL_2N":"71.9057","SYL_3N":"151.6779","SYL_5N":"","SYL_AddFavor":"0.15","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"001595","SHORTNAME":"天弘中证银行指数C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.5356","SYL_Y":"4.5573","SYL_3Y":"8.8032","SYL_6Y":"-7.9238","SYL_JN":"-6.3253","SYL_1N":"0.4568","SYL_2N":"22.7359","SYL_3N":"14.8276","SYL_5N":"","SYL_AddFavor":"4.79","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,080","FavorDate":"2020-07-01"},{"FCODE":"001668","SHORTNAME":"汇添富全球互联混合","FSRQ":"2020-07-02","SYRQ":"2020-07-02","SYL_Z":"3.658","SYL_Y":"10.9958","SYL_3Y":"36.1111","SYL_6Y":"28.8767","SYL_JN":"31.8386","SYL_1N":"43.9413","SYL_2N":"52.1345","SYL_3N":"100.3407","SYL_5N":"","SYL_AddFavor":"1.42","FUNDTYPE":"QDII","FEATURE":"311,320","FavorDate":"2020-07-01"},{"FCODE":"162213","SHORTNAME":"泰达宏利沪深300指数增强A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.3127","SYL_Y":"12.5495","SYL_3Y":"21.1401","SYL_6Y":"11.7244","SYL_JN":"12.8817","SYL_1N":"23.2996","SYL_2N":"45.1673","SYL_3N":"40.2154","SYL_5N":"59.8827","SYL_AddFavor":"3.43","FUNDTYPE":"GP,ZS","FEATURE":"050,052,053","FavorDate":"2020-07-01"},{"FCODE":"040046","SHORTNAME":"华安纳斯达克100指数","FSRQ":"2020-07-02","SYRQ":"2020-07-02","SYL_Z":"3.3733","SYL_Y":"6.1165","SYL_3Y":"33.8367","SYL_6Y":"19.4971","SYL_JN":"21.041","SYL_1N":"37.3116","SYL_2N":"54.8159","SYL_3N":"88.5566","SYL_5N":"151.2644","SYL_AddFavor":"0.43","FUNDTYPE":"QDII","FEATURE":"055,317,318","FavorDate":"2020-07-01"},{"FCODE":"000083","SHORTNAME":"汇添富消费行业混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.0596","SYL_Y":"15.133","SYL_3Y":"38.2093","SYL_6Y":"36.7051","SYL_JN":"35.319","SYL_1N":"49.6729","SYL_2N":"96.9259","SYL_3N":"134.0519","SYL_5N":"169.7263","SYL_AddFavor":"1.33","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"005918","SHORTNAME":"天弘沪深300ETF联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.6909","SYL_Y":"11.1697","SYL_3Y":"19.2048","SYL_6Y":"7.4058","SYL_JN":"8.6481","SYL_1N":"15.2622","SYL_2N":"33.3814","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"3.97","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,053","FavorDate":"2020-07-01"},{"FCODE":"161031","SHORTNAME":"富国中证工业4.0指数分级","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.7781","SYL_Y":"12.3586","SYL_3Y":"24.8549","SYL_6Y":"29.4314","SYL_JN":"33.5402","SYL_1N":"73.0433","SYL_2N":"80.5339","SYL_3N":"47.3957","SYL_5N":"0.635","SYL_AddFavor":"1.49","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,060,070","FavorDate":"2020-07-01"},{"FCODE":"110011","SHORTNAME":"易方达中小盘混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"5.8373","SYL_Y":"13.9259","SYL_3Y":"32.3275","SYL_6Y":"29.9424","SYL_JN":"27.742","SYL_1N":"38.0511","SYL_2N":"76.8389","SYL_3N":"111.4617","SYL_5N":"197.2791","SYL_AddFavor":"2.47","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"540012","SHORTNAME":"汇丰晋信恒生龙头指数A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"5.1127","SYL_Y":"8.5257","SYL_3Y":"16.7451","SYL_6Y":"5.8245","SYL_JN":"6.0972","SYL_1N":"14.7052","SYL_2N":"36.1059","SYL_3N":"41.2558","SYL_5N":"61.446","SYL_AddFavor":"2.95","FUNDTYPE":"GP,ZS","FEATURE":"050,051,053","FavorDate":"2020-07-01"},{"FCODE":"001548","SHORTNAME":"天弘上证50指数A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"7.3139","SYL_Y":"9.9653","SYL_3Y":"17.5203","SYL_6Y":"4.5651","SYL_JN":"5.0521","SYL_1N":"11.738","SYL_2N":"40.9298","SYL_3N":"37.9782","SYL_5N":"","SYL_AddFavor":"4.80","FUNDTYPE":"GP,ZS","FEATURE":"050,051,053,080","FavorDate":"2020-07-01"},{"FCODE":"100039","SHORTNAME":"富国通胀通缩主题轮动混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"2.5806","SYL_Y":"10.5783","SYL_3Y":"24.938","SYL_6Y":"28.117","SYL_JN":"31.8063","SYL_1N":"68.5825","SYL_2N":"87.2907","SYL_3N":"108.7768","SYL_5N":"97.322","SYL_AddFavor":"0.53","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"519069","SHORTNAME":"汇添富价值精选混合A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.33","SYL_Y":"11.5901","SYL_3Y":"22.5932","SYL_6Y":"13.6789","SYL_JN":"14.7112","SYL_1N":"27.2361","SYL_2N":"39.6244","SYL_3N":"55.8788","SYL_5N":"91.9715","SYL_AddFavor":"2.53","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"003766","SHORTNAME":"广发创业板ETF联接C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.1551","SYL_Y":"14.2711","SYL_3Y":"27.4373","SYL_6Y":"30.3568","SYL_JN":"33.015","SYL_1N":"52.214","SYL_2N":"46.655","SYL_3N":"31.9518","SYL_5N":"","SYL_AddFavor":"1.67","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,053,080","FavorDate":"2020-07-01"},{"FCODE":"005911","SHORTNAME":"广发双擎升级混合A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.5235","SYL_Y":"14.7158","SYL_3Y":"27.0511","SYL_6Y":"41.8384","SYL_JN":"43.3876","SYL_1N":"124.5402","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.05","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"000248","SHORTNAME":"汇添富中证主要消费ETF联接","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.4187","SYL_Y":"12.9075","SYL_3Y":"24.7751","SYL_6Y":"27.9795","SYL_JN":"27.585","SYL_1N":"31.4199","SYL_2N":"75.4512","SYL_3N":"113.4659","SYL_5N":"163.1498","SYL_AddFavor":"1.49","FUNDTYPE":"GP,ZS,ETF","FEATURE":"030,031,050,051,054","FavorDate":"2020-07-01"},{"FCODE":"162703","SHORTNAME":"广发小盘成长混合(LOF)A","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"3.7874","SYL_Y":"13.252","SYL_3Y":"24.7752","SYL_6Y":"47.0162","SYL_JN":"48.9562","SYL_1N":"113.0943","SYL_2N":"124.0133","SYL_3N":"137.7446","SYL_5N":"118.3315","SYL_AddFavor":"0.53","FUNDTYPE":"HH,LOF","FEATURE":"020,211","FavorDate":"2020-07-01"},{"FCODE":"001632","SHORTNAME":"天弘中证食品饮料指数C","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"5.9326","SYL_Y":"12.9608","SYL_3Y":"31.6902","SYL_6Y":"33.2286","SYL_JN":"31.8266","SYL_1N":"35.0218","SYL_2N":"74.7904","SYL_3N":"110.6168","SYL_5N":"","SYL_AddFavor":"0.60","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,080","FavorDate":"2020-07-01"},{"FCODE":"160222","SHORTNAME":"国泰国证食品饮料行业指数分级","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.419","SYL_Y":"13.9756","SYL_3Y":"32.5918","SYL_6Y":"30.8961","SYL_JN":"28.8993","SYL_1N":"33.1097","SYL_2N":"76.3339","SYL_3N":"129.6912","SYL_5N":"191.8729","SYL_AddFavor":"1.11","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,060,070","FavorDate":"2020-07-01"},{"FCODE":"260108","SHORTNAME":"景顺长城新兴成长混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"8.7694","SYL_Y":"15.6025","SYL_3Y":"30.5992","SYL_6Y":"27.1794","SYL_JN":"27.1112","SYL_1N":"37.9197","SYL_2N":"82.4407","SYL_3N":"130.8662","SYL_5N":"197.8555","SYL_AddFavor":"2.65","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"},{"FCODE":"110022","SHORTNAME":"易方达消费行业股票","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"6.3261","SYL_Y":"10.6988","SYL_3Y":"27.9485","SYL_6Y":"18.779","SYL_JN":"17.1083","SYL_1N":"25.2186","SYL_2N":"59.2527","SYL_3N":"91.0352","SYL_5N":"173.074","SYL_AddFavor":"1.53","FUNDTYPE":"GP","FEATURE":"","FavorDate":"2020-07-01"},{"FCODE":"162605","SHORTNAME":"景顺长城鼎益混合(LOF)","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"9.0734","SYL_Y":"15.2473","SYL_3Y":"33.2547","SYL_6Y":"27.5395","SYL_JN":"26.9663","SYL_1N":"37.4696","SYL_2N":"78.1956","SYL_3N":"123.2947","SYL_5N":"175.0196","SYL_AddFavor":"2.17","FUNDTYPE":"HH,LOF","FEATURE":"020,211","FavorDate":"2020-07-01"},{"FCODE":"161725","SHORTNAME":"招商中证白酒指数分级","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"10.4677","SYL_Y":"18.5498","SYL_3Y":"43.8476","SYL_6Y":"29.8671","SYL_JN":"27.0823","SYL_1N":"32.232","SYL_2N":"75.0428","SYL_3N":"145.0616","SYL_5N":"264.3863","SYL_AddFavor":"2.46","FUNDTYPE":"GP,ZS","FEATURE":"050,051,054,060,070","FavorDate":"2020-07-01"},{"FCODE":"009623","SHORTNAME":"长城创新驱动混合","FSRQ":"2020-07-03","SYRQ":"2020-07-03","SYL_Z":"0.36","SYL_Y":"","SYL_3Y":"","SYL_6Y":"","SYL_JN":"","SYL_1N":"","SYL_2N":"","SYL_3N":"","SYL_5N":"","SYL_AddFavor":"0.00","FUNDTYPE":"HH","FEATURE":"211","FavorDate":"2020-07-01"}]
# # data = json.dumps(jso)
# # value_title = [['FCODE','SHORTNAME','近1周','近1月','近3月','近6月','今年来','近1年','近2年','近3年','近5年'],]
# # write_excel_xls(path, "Sheet1", value_title)
# index = len(value)  # 获取需要写入数据的行数
# workbook = xlrd.open_workbook(path)  # 打开工作簿
# sheets = workbook.sheet_names()  # 获取工作簿中的所有表格
# worksheet = workbook.sheet_by_name(sheets[0])  # 获取工作簿中所有表格中的的第一个表格
# rows_old = worksheet.nrows  # 获取表格中已存在的数据的行数
# new_workbook = copy(workbook)  # 将xlrd对象拷贝转化为xlwt对象
# new_worksheet = new_workbook.get_sheet(0)  # 获取转化后工作簿中的第一个表格
# # 近1周 近1月 近3月 近6月 今年来 近1年 近2年 近3年 近5年
# for i in range(0, index):
#     # for j in range(0, len(value[i])):
#     # value =json.dumps(data[i])
#     new_worksheet.write(i+rows_old, 0, value[i]["FCODE"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 1, value[i]["SHORTNAME"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 2, value[i]["SYL_Z"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 3, value[i]["SYL_Y"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 4, value[i]["SYL_3Y"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 5, value[i]["SYL_6Y"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 6, value[i]["SYL_JN"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 7, value[i]["SYL_1N"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 8, value[i]["SYL_2N"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 9, value[i]["SYL_3N"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 10, value[i]["SYL_5N"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     # new_worksheet.write(i+rows_old, 11, value[i]["FUNDTYPE"])  # 追加写入数据，注意是从i+rows_old行开始写入
#     new_worksheet.write(i+rows_old, 11, value[i]["FSRQ"])  # 追加写入数据，注意是从i+rows_old行开始写入
# new_workbook.save(path)  # 保存工作簿
# print("xls格式表格【追加】写入数据成功！")

# write_excel_xls(book_name_xls, sheet_name_xls, value_title)
# write_excel_xls_append(book_name_xls, value1)
# write_excel_xls_append(book_name_xls, value2)
# read_excel_xls(book_name_xls)
